CREATE TABLE [dbo].[RecurringDonationCommitment]
(
[RecurringDonationCommitmentKey] [uniqueidentifier] NOT NULL,
[ContactKey] [uniqueidentifier] NOT NULL,
[DonationAmount] [decimal] (18, 4) NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_DonationAmount] DEFAULT ((0)),
[RecurringDonationFrequencyCode] [int] NOT NULL,
[PaymentMethod] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Distribution] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_Distribution] DEFAULT (''),
[Appeal] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_Appeal] DEFAULT (''),
[Campaign] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_Campaign] DEFAULT (''),
[Fund] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_Fund] DEFAULT (''),
[StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[CommitmentStatusInd] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_CommitmentStatusInd] DEFAULT ('A'),
[CommitmentNotes] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_CommitmentNotes] DEFAULT (''),
[MatchReference] [nvarchar] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_MatchReference] DEFAULT (''),
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_CreatedOn] DEFAULT (getdate()),
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_UpdatedOn] DEFAULT (getdate()),
[BranchSortCode] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_BranchSortCode] DEFAULT (''),
[BankAccountNumber] [nvarchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_BankAccountNumber] DEFAULT (''),
[BankAccountName] [nvarchar] (18) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_RecurringDonationCommitment_BankAccountName] DEFAULT ('')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[RecurringDonationCommitment] ADD CONSTRAINT [PK_RecurringDonationCommitment] PRIMARY KEY CLUSTERED ([RecurringDonationCommitmentKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RecurringDonationCommitment_ContactKey] ON [dbo].[RecurringDonationCommitment] ([ContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RecurringDonationCommitment_CreatedByUserKey] ON [dbo].[RecurringDonationCommitment] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RecurringDonationCommitment_RecurringDonationFrequencyCode] ON [dbo].[RecurringDonationCommitment] ([RecurringDonationFrequencyCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RecurringDonationCommitment_UpdatedByUserKey] ON [dbo].[RecurringDonationCommitment] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RecurringDonationCommitment] ADD CONSTRAINT [FK_RecurringDonationCommitment_ContactMain] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO
ALTER TABLE [dbo].[RecurringDonationCommitment] ADD CONSTRAINT [FK_RecurringDonationCommitment_RecurringDonationFrequencyRef] FOREIGN KEY ([RecurringDonationFrequencyCode]) REFERENCES [dbo].[RecurringDonationFrequencyRef] ([RecurringDonationFrequencyCode])
GO
ALTER TABLE [dbo].[RecurringDonationCommitment] ADD CONSTRAINT [FK_RecurringDonationCommitment_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[RecurringDonationCommitment] ADD CONSTRAINT [FK_RecurringDonationCommitment_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
GRANT REFERENCES ON  [dbo].[RecurringDonationCommitment] TO [IMIS]
GRANT SELECT ON  [dbo].[RecurringDonationCommitment] TO [IMIS]
GRANT INSERT ON  [dbo].[RecurringDonationCommitment] TO [IMIS]
GRANT DELETE ON  [dbo].[RecurringDonationCommitment] TO [IMIS]
GRANT UPDATE ON  [dbo].[RecurringDonationCommitment] TO [IMIS]
GO